import os
import pandas


file_path = 'C:/Users/123/Desktop/test-importExcel/'
fileNames = os.listdir(file_path)
file_merge = pandas.DataFrame()

for name in fileNames:
    df = pandas.read_excel(file_path+name)
    file_merge = file_merge.append(df)
file_merge.to_excel(file_path+'file_merge.xlsx',index=None)